01-01 keyboard-shortcut-reference
keyboard shortcut reference​
This will contain a table that gives the equivalent commands for different keyboard shortcuts. It does not intend to be exhaustive but instead to hit all the major ones.
| shortcut | Range function |
|---|---|
| Range related | |
| SHIFT + Space | EntireRow |
| CTRL + Space | EntireColumn |
| CTRL + A | CurrentRegion |
| CTRL + / | CurrentArray |
| Arrows | Offset() |
| SHIFT + Arrow | Resize() |
| CTRL + Arrow | End() |
| CTRL + Plus (+) | Insert() |
| CTRL + SHIFT + L | AutoFilter() |
| ALT + SEMICOLON | SpecialCells(xlCellTypeVisible) |
| Application related | |
| F9 | Calculate |
| CTRL + ALT + F9 | CalculateFull -or- CalculateFullRebuild |
TODO: finish this table